prepare("SELECT id FROM users WHERE username = ? OR email = ?"); $stmt->execute([$username, $email]); if ($stmt->fetch()) { $errors[] = "Username or email already exists."; } } catch (PDOException $e) { $errors[] = "Database error. Please try again."; } } // Create user if (empty($errors)) { try { $hashed_password = password_hash($password, PASSWORD_DEFAULT); $stmt = $DBcon->prepare("INSERT INTO users (username, fullname, email, phone, password, role) VALUES (?, ?, ?, ?, ?, 'admin')"); $stmt->execute([$username, $fullname, $email, $phone, $hashed_password]); $success = "Registration successful! You can now login."; } catch (PDOException $e) { $errors[] = "Registration failed. Please try again."; } } } } ?>
